﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Visual/Template/formulario.master" AutoEventWireup="true" CodeFile="GeneralMapAndSubReport.aspx.cs" Inherits="Visual_Procedures_Reports_GeneralMapAndSub_Report" %><%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <link href="../../../Styles/interfacemetro/css/modern-responsive.css" rel="stylesheet"type="text/css" />
    <link href="../../../Styles/interfacemetro/css/modern.css" rel="stylesheet" type="text/css" />
    <link href="../../../Styles/menustyles.css" rel="stylesheet" type="text/css" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="botoes" Runat="Server">
<br /><br /><br /><br /><br /><br /><br />
<div style="margin-left:20px;"><h2>Select an Organism</h2>
<div class="input-control select">
<asp:DropDownList ID="ddOrganism" runat="server" 
        AutoPostBack="True" onselectedindexchanged="ddOrganism_SelectedIndexChanged" Width="400px">
    </asp:DropDownList>
    </div></div>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="header" Runat="Server">
<h1>Mapping & Subtyping Report</h1>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="ConteudoDinamico" Runat="Server">

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:vsdbmConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:vsdbmConnectionString.ProviderName %>" 
        
        
        SelectCommand="SELECT sequences.idacession, sequences.definition AS sequencedefinition, sequence_map.qualifier, sequence_map.idfeature, reference_features.description AS featuredescription, sequences.idorganism, subtypes.description AS subtypedescription FROM sequences INNER JOIN sequence_map ON sequences.id = sequence_map.idsequence INNER JOIN reference_features ON sequence_map.idfeature = reference_features.id INNER JOIN sequence_subtype ON sequences.id = sequence_subtype.idsequence INNER JOIN subtypes ON sequence_subtype.idsubtype = subtypes.id WHERE (sequences.idorganism = 0)">
    </asp:SqlDataSource>
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
        Font-Size="8pt" InteractiveDeviceInfos="(Collection)" 
        WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="750px" 
        ZoomPercent="90" onreportrefresh="ReportViewer1_ReportRefresh">
        <localreport reportpath="App_Code\reports\MapSubReport.rdlc">
            <datasources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
            </datasources>
        </localreport>
    </rsweb:ReportViewer>
</asp:Content>

